package com.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.bean.LoginBean;

public class userrcdadd extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
	HttpSession session = request.getSession();
	request.setCharacterEncoding("UTF-8");
	LoginBean bean = (LoginBean) session.getAttribute("Loginbean");
	String dept = bean.getDept();
	String username = request.getParameter("username");
	String xiangmu = request.getParameter("xiangmu");
	String begindate = request.getParameter("begindate");
	String enddate = request.getParameter("enddate");
	String details = request.getParameter("details");
	try {
		Class.forName("com.mysql.jdbc.Driver");
	} catch (ClassNotFoundException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	String url = "jdbc:mysql://localhost:3306/graduatedesign";
	Connection conn = null;
	String sql = "insert into userrecord (username,xiangmu,begindate,enddate,details,dept) values (?,?,?,?,?,?)";
	try {
		conn = DriverManager.getConnection(url, "root", "root");
		PreparedStatement preStmt = conn.prepareStatement(sql);
		preStmt.setString(1, username);
		preStmt.setString(2, xiangmu);
		preStmt.setString(3, begindate);
		preStmt.setString(4, enddate);
		preStmt.setString(5, details);
		preStmt.setString(6, dept);
		int suc = preStmt.executeUpdate();
		if (suc != 0) {	
			session.setAttribute("suc", suc);
			response.sendRedirect("admin/userrcdmanage.jsp") ;
		}
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {

	doGet(request, response);
}







}
